-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: mysql5.cws.oregonstate.edu
-- Generation Time: May 22, 2019 at 12:40 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.3-7+squeeze9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cw_61046`
--

-- --------------------------------------------------------

--
-- Table structure for table `CodesManag`
--

CREATE TABLE IF NOT EXISTS `CodesManag` (
  `ManagType` text NOT NULL,
  `ManageCode` text NOT NULL,
  `ManagDescrip` text NOT NULL,
  `ManagNotes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CodesManag`
--

INSERT INTO `CodesManag` (`ManagType`, `ManageCode`, `ManagDescrip`, `ManagNotes`) VALUES
('APP_MATER', '0N15P0K', 'NPK fertilizer (0-15-0, superphosphate) - Periodic application (kg dry weight/ha/week)', '1'),
('APP_MATER', '15.5N0P0K', 'NPK fertilizer (15.5-0-0, calcium nitrate)) - Periodic application (kg dry weight/ha/week)', '1'),
('APP_MATER', '16N20P0K', 'NPK fertilizer (16-20-0) - Periodic application (kg dry weight/ha/week)', '1'),
('APP_MATER', '18N46P0K', 'NPK fertilizer (18-46-0) ) - Periodic application (kg dry weight/ha/week)', '1'),
('MANAG_CODE', 'AER_CIRC_CONTINUOUS', 'Aeration: water circulator type, usage continuous (kWhr/ha/day)', '10'),
('MANAG_CODE', 'AER_CIRC_DEMAND', 'Aeration: water circulator type, usage based on maintenance of minimum dissolved oxygen level (kWhr/ha/day)', '10'),
('MANAG_CODE', 'AER_NONE', 'Aeration: none used (default condition)', '10'),
('MANAG_CODE', 'AER_SURF_CONTINUOUS', 'Aeration: surface agitator type, usage continuous (kWhr/ha/day)', '10'),
('MANAG_CODE', 'AER_SURF_DEMAND', 'Aeration: surface agitator type, usage based on maintenance of minimum dissolved oxygen level (kWhr/ha/day)', '10'),
('PROD_FISH', 'AUR', 'Blue tilapia - Oreochromis aureus (fish per square meter)', 'Oreochromis aureus'),
('PROD_FISH', 'BCP', 'Black carp - Mylopharyngodon piceus (fish per square meter)', 'Mylopharyngodon piceus'),
('APP_MATER', 'CAC', 'Calcium carbonate (CaCO3) - Periodic application (kg dry weight/ha/week)', '1'),
('APP_MATER', 'CAC_AND_CAO', 'Calcium carbonate (CaCO3) and Calcium oxide (CaO) - Periodic application (kg dry weight/ha/week)', '1'),
('APP_MATER', 'CAM', 'Calcium-magnesium carbonate (CaMg(CO3)2) - Periodic application (kg dry weight/ha/week)', '1'),
('APP_MATER', 'CAO', 'Calcium oxide (CaO) - Periodic application (kg dry weight/ha/week)', '1'),
('APP_MATER', 'CASSAVA', 'Cassava plant material (tubers: soaked, dried, and ground) - Periodic application (kg dry weight/ha/week)', '2'),
('PROD_FISH', 'CCP', 'Common carp - Cyprinus carpio (fish per square meter)', 'Cyprinus carpio'),
('PROD_FISH', 'CHA', 'Milkfish - Chanos chanos (fish per square meter)', 'Chanos chanos'),
('APP_MATER', 'CHICK', 'Chicken manure (air dried, may include straw, rice hull, etc.) - Periodic application (kg dry weight/ha/week)', '2'),
('PROD_FISH', 'CICHL', 'Guapote tigre, mojarra pinta, tiger cichlid - Cichlasoma managuense (fish per square meter)', 'Cichlasoma managuense. Family cichlid. This fish has been used in Central America as a predator for tilapia culture (polyculture). They are very voracious and can eat tilapia juveniles\r\nthat are fairly large, their mouth is protractile allowing them to catch\r\nlarge prey..\r\n\r\nThey are sold in aquaria as pets.'),
('PROD_FISH', 'COLOS', 'Cachama (Columbia), tambaqui (Brazil) - Colossoma macropomum (fish per square meter)', 'Colossoma macropomum'),
('APP_MATER', 'COW', 'Cow  manure - Periodic application (kg dry weight/ha/week)', '2'),
('APP_MATER', 'CYPERUS', 'Cyperus plant material - Periodic application (kg dry weight/ha/week)', '2'),
('APP_MATER', 'DAP', 'Di-ammonium phosphate ((NH4)2-HPO4) - Periodic application (kg dry weight/ha/week)', '1'),
('APP_MATER', 'DGRASS', 'Dry-grass plant material - Periodic application (kg dry weight/ha/week)', '2'),
('MANAG_CODE', 'EXP_FAILED', 'Experiment is listed in database (project table) but study failed, with partial or no data available', '10'),
('MANAG_CODE', 'EXP_NOT_PERFORMED', 'Experiment is listed in database (project table) but experiment not performed, no data available', '10'),
('PROD_FISH', 'FAC_NIL', 'Nile tilapia - Oreochromis niloticus, Freshwater Aquaculture Center, Philippines strain (fish per square meter)', 'Oreochromis niloticus, Freshwater Aquaculture Center (Philippines) strain'),
('APP_MATER', 'FEED', 'Fish feed (feed type and composition are given under application materials) - Periodic application (kg dry weight/ha/week)', '3'),
('MANAG_CODE', 'FEED_DELAYED', 'Feed application: supplemental feeding delayed beyond start time of study (value = delay period, days)', '3'),
('MANAG_CODE', 'FEED_SPEC_FISHWT', 'Feed application: constant percent fish biomass per day; usually wet weight fish and feed, where feed moisture content is about 10%', '3'),
('MANAG_CODE', 'FEED_SPEC_KGHAD', 'Feed application: rate per area (kg dry wt./ha/week; some use of kg dry wt./ha/day)', '3'),
('MANAG_CODE', 'FEED_SPEC_RESPON', 'Feed application: variable percent fish biomass per day. Feed rate is a function of fish weight, using feeding table, formula, ad libitum.', '3'),
('APP_MATER', 'FEED1', 'Additional feed type (when > 1 feed types used)  - Periodic application (kg dry weight/ha/week)', '3'),
('APP_MATER', 'FEED2', 'Additional feed type (when > 2 feed types used) - Periodic application (kg dry weight/ha/week)', '3'),
('APP_MATER', 'FEED3', 'Additional feed type (when > 3 feed types used) - Periodic application (kg dry weight/ha/week)', '3'),
('MANAG_CODE', 'FERT_FREQ', 'Fertilization: application frequency (interval; days)', '1'),
('MANAG_CODE', 'FERT_SPEC_KGHAWK', 'Fertilization: per area rate (kg dry wt./ha/week; some use of kg dry wt./ha/day). This code name is normally replaced with a specific compound code.', '1'),
('MANAG_CODE', 'FERT_SPEC_MIN_ALK', 'Fertilization: lime/alkalinity compound applied to maintain a minimum total alkalinity (value = minimum mg CaCO3/L)', '1'),
('MANAG_CODE', 'FERT_SPEC_N', 'Fertilization: application rate specified in terms of nitrogen (kg N/ha/wk)', '1'),
('MANAG_CODE', 'FERT_SPEC_N_RESP', 'Fertilization: nitrogen application rate responsive to nutrient concentrations, phytoplankton concentration, or other basis', '1'),
('MANAG_CODE', 'FERT_SPEC_P', 'Fertilization: application rate specified in terms of phosphorous (kg P/ha/wk)', '1'),
('MANAG_CODE', 'FERT_SPEC_P_RESP', 'Fertilization: phosphorous application rate responsive to nutrient concentrations, phytoplankton concentration, or other basis', '1'),
('MANAG_CODE', 'FERT_STOPPED', 'Fertilization: application started before or at beginning of study and then stopped before end of study when supplemental feeding is begun (value = period over which fertilizer is applied, days)', '1'),
('MANAG_CODE', 'FISH_HARVEST', 'Fish handling event: fish harvest', '10'),
('MANAG_CODE', 'FISH_IN_CAGES_IN_PONDS', 'Fish culture, special: fish reared in cages placed in ponds', '10'),
('MANAG_CODE', 'FISH_IN_PONDS_WITH_CAGES', 'Fish culture, special: fish reared in ponds that contain cages', '10'),
('MANAG_CODE', 'FISH_IN_RU', 'Fish culture: fish stocked in rearing units with no special considerations (stocking density, fish/m2)', '10'),
('MANAG_CODE', 'FISH_OBSERV', 'Fish observation event: value depends on data field', '10'),
('MANAG_CODE', 'FISH_REMOVED', 'Fish handling event: fish removed, before final harvest or unwanted species', '10'),
('MANAG_CODE', 'FISH_SAMPLE', 'Fish handling event: fish size sampling', '10'),
('MANAG_CODE', 'FISH_STOCK', 'Fish handling event: fish stocking', '10'),
('PROD_FISH', 'FISH_UNKNOWN', 'Unknown fish name (fish per square meter)', 'Unknown fish specie'),
('APP_MATER', 'GALL', 'Gall plant material - Periodic application (kg dry weight/ha/week)', '2'),
('PROD_FISH', 'GARIE', 'Clarias, African catfish - Clarias gariepinus (fish per square meter)', 'Clarias gariepinus'),
('APP_MATER', 'GGRASS', 'Green-grass plant material - Periodic application (kg dry weight/ha/week)', '2'),
('APP_MATER', 'INITIAL_CAC', 'Calcium carbonate (CaCO3) - Initial application (kg dry weight per hectare)', '1'),
('APP_MATER', 'INITIAL_CAC_AND_CAO', 'Calcium carbonate (CaCO3) and Calcium oxide (CaO) - Initial application (kg dry weight per hectare)', '1'),
('APP_MATER', 'INITIAL_CAM', 'Calcium-magnesium carbonate (CaMg(CO3)2) - Initial application (kg dry weight per hectare)', '1'),
('APP_MATER', 'INITIAL_CAO', 'Calcium oxide (CaO) - Initial application (kg dry weight per hectare)', '1'),
('APP_MATER', 'INITIAL_CHICK', 'Chicken manure (air dried, may include straw, rice hull, etc.) - Initial application (kg dry weight per hectare)', '2'),
('APP_MATER', 'INITIAL_SP', 'Super phosphate (???% P) - Initial application (kg dry weight per hectare)', '1'),
('APP_MATER', 'INITIAL_SP_OR_TSP', 'Super phosphate or Triple super phosphate - Initial application (kg dry weight per hectare)', '1'),
('APP_MATER', 'INITIAL_TSP', 'Triple super phosphate (0N-46P-0K, 42% P2O5) - Initial application (kg dry weight per hectare)', '1'),
('APP_MATER', 'INITIAL_UNKNOWN', 'Unknown application material - Initial application (kg dry weight per hectare)', '1'),
('APP_MATER', 'INITIAL_UREA', 'Urea nitrogren (47N-0P-0K) - Initial application (kg dry weight per hectare)', '1'),
('APP_MATER', 'MGERM', 'Maize germ - Periodic application (kg dry weight/ha/week)', '2'),
('PROD_FISH', 'MON', 'Monodon shrimp - Penaeus monodon (fish per square meter)', 'Penaeus monodon'),
('PROD_FISH', 'MUL', 'Mullet - Mugil curema (fish per square meter)', 'Mugil curema'),
('PROD_FISH', 'MXG', 'Hybrid clarius - Clarias macrocephalus x C. gariepinus (fish per square meter)', 'Clarias macrocephalus x C. gariepinus'),
('APP_MATER', 'NAC', 'Sodium carbonate (Na2CO3) - Periodic application (kg dry weight/ha/week)', '1'),
('APP_MATER', 'NAHCO3', 'Sodium bicarbonate (NaHCO3) - Periodic application (kg dry weight/ha/week)', '1'),
('APP_MATER', 'NH4PO4', 'Ammonium phosphate (NH4-H2PO4) - Periodic application (kg dry weight/ha/week)', '1'),
('PROD_FISH', 'NIL', 'Nile tilapia - Oreochromis niloticus, Africa ivory coast or Egypt strain (fish per square meter)', 'Oreochromis niloticus, ivory coast or Egypt strain'),
('PROD_FISH', 'NIL1', 'Nile tilapia - additional second size class (fish per square meter)', 'NIL, additional fish size class 1'),
('PROD_FISH', 'NIL2', 'Nile tilapia - additional third size class (fish per square meter)', 'NIL, additional fish size class 2'),
('PROD_FISH', 'NIL3', 'Nile tilapia - additional fourth size class (fish per square meter)', 'NIL, additional fish size class 2'),
('PROD_FISH', 'NIL4', 'Nile tilapia - additional fifth size class (fish per square meter)', 'NIL, additional fish size class 2'),
('PROD_FISH', 'PACO', 'Paco or Pacu - Piaractus brachypomus (fish per square meter)', 'Piaractus brachypomus'),
('APP_MATER', 'RBRAN', 'Rice bran (not de-fatted) - Periodic application (kg dry weight/ha/week)', '2'),
('PROD_FISH', 'RED_NIL', 'Red Nile tilapia - Oreochromis niloticus, red hybrid (fish per square meter)', 'Oreochromis niloticus, red hybrid'),
('PROD_FISH', 'SGMT_NIL', 'Nile tilapia - Oreochromis niloticus, genetically male tilapia, Swansea stock (fish per square meter)', 'Oreochromis niloticus, genetically male tilapia, Swansea stock'),
('APP_MATER', 'SP', 'Super phosphate (???% P) - Periodic application (kg dry weight/ha/week)', '1'),
('APP_MATER', 'SP_OR_TSP', 'Super phosphate or Triple super phosphate - Periodic application (kg dry weight/ha/week)', '1'),
('PROD_FISH', 'STRIA', 'Dalag - Channa striata  (fish per square meter)', 'Channa striata'),
('PROD_FISH', 'STY', 'Stylirostis shrimp - Penaeus stylirostis (fish per square meter)', 'Penaeus stylirostis'),
('PROD_FISH', 'THAI_NIL', 'Nile tilapia - Oreochromis niloticus, Thailand strain (fish per square meter)', 'Oreochromis niloticus, Thailand strain'),
('APP_MATER', 'TITON', 'Titonia plant material (Compositae family; shrub, leaves used) - Periodic application (kg dry weight/ha/week)', '2'),
('MANAG_CODE', 'TREAT_RU_DRAIN', 'Treatment: replicates of treatment are being drained and provide effluent water quality', '10'),
('MANAG_CODE', 'TREAT_SOIL_SAMPLE', 'Treatment: replicates represent combined soil samples applicable to entire study', '10'),
('MANAG_CODE', 'TREAT_SPECIAL', 'Treatment: special treatment variables, see explanation at project description (under main menu item: CRSP projects)', '10'),
('MANAG_CODE', 'TREAT_SPECS_UNKNOWN', 'Treatment: treatment specifications have either (1) not been established (some older studies), (2) have not been entered into the database (new dataset submissions), or (3) experimental treatments were not used  (see project description)', '10'),
('MANAG_CODE', 'TREAT_TEMP_DATA', 'Treatment: provides water temperature data applicable to entire study', '10'),
('MANAG_CODE', 'TREAT_WATER_INLET', 'Treatment: water inlet station, source (influent) water data applicable to entire study or specific replicate', '10'),
('MANAG_CODE', 'TREAT_WQDATA_NOFISH', 'Treatment: water quality data only, no fish culture performed (e.g., estuary sampling in Honduras)', '10'),
('APP_MATER', 'TSP', 'Triple super phosphate (0N-46P-0K, 42% P2O5) - Periodic application (kg dry weight/ha/week)', '1'),
('APP_MATER', 'UNKNOWN', 'Unknown application material - Periodic application (kg dry weight/ha/week)', '1'),
('APP_MATER', 'UREA', 'Urea nitrogren (47N-0P-0K) - Periodic application (kg dry weight/ha/week)', '1'),
('PROD_FISH', 'VAN', 'Vannamei shrimp - Penaeus vannamei (fish per square meter)', 'Penaeus vannamei'),
('MANAG_CODE', 'WAT_FLOW_EXCH', 'Water management: continuous flow or daily exchange (%/day)', '10'),
('MANAG_CODE', 'WAT_FLOW_EXCH_DELAYED', 'Water management: daily water exchange started after given time from fish stocking (days)', '10'),
('MANAG_CODE', 'WAT_FLOW_EXCH_EMERG', 'Water management: water exchange as needed to maintain water quality (e.g. dissolved oxygen) (%/day)', '10'),
('MANAG_CODE', 'WAT_FLOW_MAKEUP', 'Water management: water loss makeup (evaporation and seepage) and overflow (precipitation and runoff) (management water depth, m)', '10'),
('MANAG_CODE', 'WAT_FLOW_NONE', 'Water management: none', '10'),
('MANAG_CODE', 'WAT_TARG_DEPTH', 'Water management: target water depth (m). If not specified, then water depth is not a treatment variable', '10'),
('PROD_FISH', 'ZIL', 'Zilli tilapia - Tilapia zilliei (fish per square meter)', 'Tilapia zilliei');
